/*
 *  Copyright 2001-2004 The Apache Software Foundation
 *
 *  Licensed under the Apache License, Version 2.0 (the "License");
 *  you may not use this file except in compliance with the License.
 *  You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing, software
 *  distributed under the License is distributed on an "AS IS" BASIS,
 *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *  See the License for the specific language governing permissions and
 *  limitations under the License.
 */
package ar.uba.fi.posgrado.economy.dao.impl;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.criterion.Expression;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.ObjectRetrievalFailureException;
import org.springframework.orm.hibernate3.HibernateCallback;

import ar.uba.fi.posgrado.common.dao.AbstractDAO;
import ar.uba.fi.posgrado.common.dao.DAOException;
import ar.uba.fi.posgrado.common.dao.NoSuchEntityException;
import ar.uba.fi.posgrado.economy.dao.BenefitDAO;
import ar.uba.fi.posgrado.economy.model.Benefit;
import ar.uba.fi.posgrado.economy.model.BenefitStatus;

/**
 * Implementacion de {@linkplain BenefitDAO benefit DAO}
 * 
 * @author nicolas.gonzalez
 * @author pablo.tortorella
 * 
 * @see AbstractDAO
 * @see BenefitDAO
 */
public class BenefitDAOImpl extends AbstractDAO<Benefit> implements BenefitDAO {

	/**
	 * @see ar.uba.fi.posgrado.common.dao.AbstractDAO#getClazz()
	 */
	@SuppressWarnings("unchecked")
	@Override
	protected Class getClazz() {
		return Benefit.class;
	}

	/**
	 * @see ar.uba.fi.posgrado.economy.dao.BenefitDAO#findByDescription(java.lang.String)
	 */
	@SuppressWarnings("unchecked")
	public Benefit findByDescription(final String description)
			throws NoSuchEntityException, DAOException {
		Benefit response = null;
		try {
			response = (Benefit) this.getHibernateTemplate().execute(
					new HibernateCallback() {
						public Object doInHibernate(Session session) {
							Criteria criteria = session
									.createCriteria(Benefit.class);
							criteria.add(Expression.eq("description",
									description));
							return criteria.uniqueResult();
						}
					});

			if (response == null) {
				// Necesario ya q el criteria no falla al no encontrar
				throw new NoSuchEntityException(
						"No existe intancia de Beneficio"
								+ ", con description: " + description);
			}
		} catch (ObjectRetrievalFailureException e) {
			throw new NoSuchEntityException("No existe intancia de Beneficio"
					+ ", con description: " + description, e);
		} catch (DataAccessException e) {
			throw new DAOException(
					"Excepcion al buscar una intancia de Beneficio "
							+ ", con description: " + description
							+ ". Mensaje: " + e.getMessage(), e);
		}

		return response;
	}

    /**
     * @see ar.uba.fi.posgrado.economy.dao.BenefitDAO#findByStatus(ar.uba.fi.posgrado.common.model.Benefit.BenefitStatus)
     */
    @SuppressWarnings("unchecked")
    public List<Benefit> findByStatus(final BenefitStatus status) throws DAOException {
        List response = null;
        
        try {
            response = (List)this.getHibernateTemplate().execute(
                    new HibernateCallback() {
                        public Object doInHibernate(Session session)
                                throws HibernateException, SQLException {
                            Criteria criteria = session.createCriteria(Benefit.class);
                            criteria.add(Expression.eq("status", status));
                            return criteria.list();
                        }
                    }
            );
            if (response == null) {
                response = new ArrayList<Benefit>();
            }
        } catch (DataAccessException e) {
            throw new DAOException(
                    "Excepcion al buscar beneficios con Status: " + status + 
                            ". Mensaje: " + e.getMessage(), e);
        }
        
        return response;
    }

	
	
	
	
}
